Release 10.1A: OpenEdge Data Management:
Database Administration

PROSTRCT ADDONLINE qualifier

Appends the files from a new structure description (.st) file to an online database.

Syntax

prostrct addonline db-name [ structure-description-file ] [ -validate ]

Parameters

db-name

Specifies the database you are using.

structure-description-file

Specifies the new .st file. Do not use db-name.st.

-validate

Parses the contents of the .st file for syntax errors. When -validate is specified, the database is not created. Each line of the structure file is read and evaluated. If errors are detected, the type of error is reported along with the line number. For a discussion of the syntax and rule checking -validate provides, see the "Validating structure description files" section.

Use PROSTRCT ADDONLINE to add new storage areas and extents to new or existing storage areas to an online database.

Notes

PROSTRCT ADDONLINE has the following restrictions:
If your database has after-imaging enabled, you cannot add new data areas. You may only add new extents to existing data areas, or additional after-image areas.
You may not have more than one instance of PROSTRCT ADDONLINE executing at a single time.
If currently connected users will not have sufficient privileges to access the new extents, you may proceed with the online add, but an under-privileged user will be disconnected from the database the first time it tries to open one of the new extents. This open may occur at an unpredictable time, such as when the user needs to find space in the buffer pool. PROSTRCT ADDONLINE verifies the status of current users before adding new extents, and prompts you to confirm that you wish to proceed.
If ADDONLINE fails, the newly created files will be deleted.
For a discussion and examples of PROSTRCT ADDONLINE, see the "OpenEdge Structure Add Online utility" section.